PostgreSQL
Data Types
Data Types: bigint
Data Types: box
Data Types: jsonb
Data Types: macaddr8
Data Types: timestamp
Network Address Types: macaddr
Numeric Types: smallint
Object Identifier Types: regconfig
Pseudo-Types: anyelement
Pseudo-Types: internal
Pseudo-Types: tsm_handler
Text Search Types: tsquery
Queries
Combining Queries (UNION, INTERSECT, EXCEPT): EXCEPT
Table Expressions: GROUP BY and HAVING Clauses
WITH Queries: SELECT in WITH